package com.henz4help.app.db;

public class HenzDB {
	
	public static final class TPersonalData {
		
		public static final String TABLE_NAME = "personaldata";
		
		public static final String EMAIL = "email";
		
		public static final String FIRST_NAME = "firstname";
		
		public static final String MIDDLE_INITIAL = "middleinitial";
		public static final String LAST_NAME = "lastname";
		public static final String BIRTH_DAY = "birthday";
		public static final String BIRTH_MONTH = "birthmonth";
		public static final String BIRTH_YEAR = "birthyear";
		public static final String GENDER = "gender";
		public static final String ADDRESS = "address";
		public static final String CITY = "city";
		public static final String STREET = "street";
		public static final String APARTMENT = "apartment";
		
		public static final String LATITUDE = "latitude";
		public static final String LONGITUDE = "longitude";
		
		
		public static final String INSURANCE = "insurance";
		public static final String INSURANCE_ACCOUNT_NO = "insuranceaccountno";
		public static final String ORGAN_DONOR = "organdonor";
		public static final String ADDITIONAL_MESSAGE = "additionalmessage";
		public static final String URI_STRING = "uriString";
		public static final String ZIP = "zip";
		public static final String STATE = "state";
		public static final String CREATE_DATE = "createdate";
		public static final String UPDATE_DATE = "updatedate";
		
		public static final String CREATE = ""//
			+ "create table "//
			+ TABLE_NAME//
			+ "("//
			+ EMAIL + " text, "//
			+ FIRST_NAME + " text, "//
			+ MIDDLE_INITIAL + " text, "//
			+ LAST_NAME + " text, "//
			+ BIRTH_DAY + " int,"//
			+ BIRTH_MONTH + " int,"//
			+ BIRTH_YEAR + " int,"//
			+ GENDER + " text,"//
			+ ADDRESS + " text,"//
			+ CITY + " text,"//
			+ STREET + " text,"//
			+ ZIP + " text,"//
			+ STATE + " text,"//
			+ APARTMENT + " text,"//

			+ LATITUDE + " text,"//
			+ LONGITUDE + " text,"//

			+ INSURANCE + " text,"//
			+ INSURANCE_ACCOUNT_NO + " text,"//
			+ ORGAN_DONOR + " text,"//
			+ ADDITIONAL_MESSAGE + " text,"//
			+ URI_STRING + " text,"//
			+ CREATE_DATE + " long,"//
			+ UPDATE_DATE + " long" //
			+ ");"//
		;
	}
}
